Oracle Autonomous Database is an all-in-one cloud database solution for data marts, data lakes, operational reporting, and batch data processing. Oracle uses machine learning to completely automate all routine database tasks—ensuring higher performance, reliability, security, and operational efficiency.
What you can do with Oracle Database and Profit.co Integration:
Integrate Oracle Database fields using query in Profit.co key result and automate the progress.
Configure Oracle Database KPI in Profit.co
Note: Only Super Users can be able to configure the Profit.co <> Oracle Database Integrations.
Step 1
Navigate to Settings from the left navigation panel.
Click on Integrations, On the Connectors page, Select the Business Level tab and click on the Oracle DB Manage button.
Then click the Connect to Oracle DB button.
Step 2
Enter the Connection Name and required details and click on Connect button to successfully configure the Oracle DB Integration connection
Step 3
Now Create a key result Using the Form in Profit.co where you want to integrate the Oracle DB in a key result.
Note: Oracle DB KPI supports Increase KPI, Decrease KPI, and Control KPI type.
Choose the required KPI.
Click the Automate Check-in and choose Oracle DB from the Connection dropdown.
On the Connect to Oracle DB tab, Enter the Query and Run the query, you will get the Current Value.
Then, click Add.
Once the Key Result is successfully created, click on the Check-in button and complete the Check-in to update the status value in the key result.
If you check-in you’ll be redirected to the review page. Finally, you can Update it to make progress to your key result.
Note: The automatic check-in will happen every day at 09:00 AM based on the user region.